Learning Analytics with Excel Pivot Tables
نویسندگان
چکیده
Different actors like teachers, course designers and content providers need to gain more information about the way the resources provided with Moodle are used by the students so they can adjust and adapt their offer better. In this contribution we show that Excel Pivot Tables can be used to conduct a flexible analytical processing of usage data and gain valuable information. An advantage of Excel Pivot Tables is that they can be mastered by persons with good IT-skills but not necessarily computer scientists.
منابع مشابه
Pivot Tables/Charts - Magic Beans without Living in a Fairy Tale
This presentation will show how one analyst uses the pivot table feature of Microsoft EXCEL to arrive at a quick performance analysis for DB2 and BATCH mainframe applications. At our enterprise, we use pivot tables and charts as monitoring tools, performance analysis, and management communication. An explanation of the basic concepts to create and manipulate pivot tables will be combined with a...
متن کاملFast Foreign-Key Detection in Microsoft SQL Server PowerPivot for Excel
Microsoft SQL Server PowerPivot for Excel, or PowerPivot for short, is an in-memory business intelligence (BI) engine that enables Excel users to interactively create pivot tables over large data sets imported from sources such as relational databases, text files and web data feeds. Unlike traditional pivot tables in Excel that are defined on a single table, PowerPivot allows analysis over mult...
متن کاملAn Efficient Approach for Providing multidimensional Data on Relational DBMSs
Multidimensional data are used in popular to support OLAP(On-Line Analytical Processing) operations efficiently. Many OLAP tools have been developed to manipulate the multidimensional data to provide users with useful information for decision making. While they are equipped with useful features, they seem be sometimes complicated to relational database users. In this paper, we developed an easy...
متن کاملMultimedia Pivot Tables
Image collections are a tremendous source of information. Yet due to the semantic gap it is difficult to get access to their content, while at the same time it is difficult to properly employ their context such as tags and metadata. To move forward we propose a multimedia analytics solution. The most widespread and universally used analytic tools are spreadsheets, where a powerful feature is th...
متن کاملAggregation Everywhere
This paper describes the Phoenix system, which loads a data warehouse and then reports against it. Between the raw atomic data of the source system and the business measures presented to users there are many computing environments. Aggregation occurs everywhere: initial bucketing by the natural keys on the mainframe, loading the fact table using a mapping table, maintaining aggregate tables and...
متن کامل